How Brick and Mortar Customers can use intelligent WiFi to stay competitive




Outline

  • Motivation
  • Data Wrangling Process
  • Value proposition
  • Brick & Mortar Shop Case Study
  • Brick & Mortar Case Study
  • Interactive Dashboard Demo

Motivation

The objective of this presentation is to demonstrate how a brick and mortar customer can leverage customer foot traffic data, collected by Meraki and enhanced by latest data wrangling methodology, interact with different elements of its own data to gain better insight & make sound decisions.

Assumptions

The reader of this document is assumed to already understand Cisco Meraki networks and proximity API data retrieval from Meraki Cloud. The presentation doesn’t include network infrastructure set up or the API call to the Meraki Cloud. Presentation focuses on data wrangling process and the interactive dashboard that is developed with open source data wrangling, java script and dashboard frame works softwares. It doesn’t include steps for data tidying.

Data Wragling Process

Value Proposition

Example Case Study

BB’s Pretzel Franchise - (fictional)

Customer Questions?

  • What does my Data show me about the state of my business?
  • How are my stores customer traffic relative to one another?
  • Which store(s) and what region of the country is performing well/poorly?
  • Can I integrate my inventory to the data traffic to help manage my supply chain per store?
  • Can I integrate my Point of Sale data and create up-sale opportunity?

BB’s Pretzel Custom Dashboard developed with curated data.

Screen Capture of the Dashboard

Elements of the dashboard explained

Use Chrome browser for best experience

Video Recording of the App

Refrences

Credit

  • Rstudio
  • Cisco Meraki
  • Plotly
  • rstat community
  • Javascript community
  • John Hopkins Bloomberg School of Public Health

End